SherbyNet - /page/wikibook/entry.mu

Micron Document

`:top

An `!object–relational database`! (`!ORD`!), or `!object–relational database management system`! (`!ORDBMS`!), is a `F33f`_`[database management system`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Database_management_system]`_`f (DBMS) similar to a `F33f`_`[relational database`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Relational_database]`_`f, but with an `F33f`_`[object-oriented database`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object_database]`_`f model: `F33f`_`[objects`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object_(computer_science)]`_`f, `F33f`_`[classes`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Class_(computer_programming)]`_`f and `F33f`_`[inheritance`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Inheritance_(object-oriented_programming)]`_`f are directly supported in `F33f`_`[database schemas`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Database_schema]`_`f and in the `F33f`_`[query language`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Query_language]`_`f. Also, as with pure relational systems, it supports extension of the `F33f`_`[data model`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Data_model]`_`f with custom `F33f`_`[data types`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Data_type]`_`f and `F33f`_`[methods`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Method_(computer_programming)]`_`f.

An object–relational database can be said to provide a middle ground between relational databases and `F33f`_`[object-oriented databases`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object_database]`_`f. In object–relational databases, the approach is essentially that of relational databases: the data resides in the database and is manipulated collectively with queries in a query language; at the other extreme are OODBMSes in which the database is essentially a persistent object store for software written in an `F33f`_`[object-oriented programming`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object-oriented_programming]`_`f language, with an application programming interface `F33f`_`[API`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=API]`_`f for storing and retrieving objects, and little or no specific support for querying.

>>Contents

• `F0af`_`[Overview`#overview]`_`f

• `F0af`_`[History`#history]`_`f

• `F0af`_`[Comparison to RDBMS`#comparison-to-rdbms]`_`f

• `F0af`_`[See also`#see-also]`_`f

• `F0af`_`[References`#references]`_`f

• `F0af`_`[External links`#external-links]`_`f

-─

>>Overview

The basic need of object–relational database arises from the fact that both Relational and Object database have their individual advantages and drawbacks. The isomorphism of the relational database system with a mathematical relation allows it to exploit many useful techniques and theorems from set theory. But these types of databases are not optimal for certain kinds of applications. An object oriented database model allows containers like sets and lists, arbitrary user-defined datatypes as well as nested objects. This brings commonality between the application type systems and database type systems which removes any issue of impedance mismatch. But object databases, unlike relational do not provide any mathematical base for their deep analysis.`:cite-ref-fstajano-2-0[`F5bf`_`[2`#cite-note-fstajano-2]`_`f]`:cite-ref-namansg-3-0[`F5bf`_`[3`#cite-note-namansg-3]`_`f]

The basic goal for the object–relational database is to bridge the gap between relational databases and the `F33f`_`[object-oriented modeling`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object-oriented_modeling]`_`f techniques used in programming languages such as `F33f`_`[Java`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Java_(programming_language)]`_`f, `F33f`_`[C++`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=C++]`_`f, `F33f`_`[Visual Basic (.NET)`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Visual_Basic_(.NET)]`_`f or `F33f`_`[C#`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=C_Sharp_(programming_language)]`_`f. However, a more popular alternative for achieving such a bridge is to use a standard relational database systems with some form of `F33f`_`[object–relational mapping`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object–relational_mapping]`_`f (ORM) software. Whereas traditional `F33f`_`[RDBMS`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=RDBMS]`_`f or SQL-DBMS products focused on the efficient management of data drawn from a limited set of data-types (defined by the relevant language standards), an object–relational DBMS allows software developers to integrate their own types and the methods that apply to them into the DBMS.

The ORDBMS (like `F33f`_`[ODBMS`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=ODBMS]`_`f or `F33f`_`[OODBMS`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=OODBMS]`_`f) is integrated with an `F33f`_`[object-oriented programming`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object-oriented_programming]`_`f language. The characteristic properties of ORDBMS are 1) complex data, 2) type inheritance, and 3) object behavior. `*Complex data`* creation in most SQL ORDBMSs is based on preliminary schema definition via the `F33f`_`[user-defined type`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=User-defined_type]`_`f (UDT). Hierarchy within structured complex data offers an added property, `*type inheritance`*. That is, a structured type can have subtypes that reuse all of its attributes and contain additional attributes specific to the subtype. Another advantage, the `*object behavior`*, is related with access to the program objects. Such program objects must be storable and transportable for database processing, therefore they usually are named as persistent objects. Inside a database, all the relations with a persistent program object are relations with its `F33f`_`[object identifier`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object_identifier]`_`f (OID). All of these points can be addressed in a proper relational system, although the SQL standard and its implementations impose arbitrary restrictions and additional complexity`:cite-ref-4[`F5bf`_`[4`#cite-note-4]`_`f]

In `F33f`_`[object-oriented programming`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object-oriented_programming]`_`f (OOP), object behavior is described through the methods (object functions). The methods denoted by one name are distinguished by the type of their parameters and type of objects for which they attached (`F33f`_`[method signature`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Method_signature]`_`f). The OOP languages call this the `F33f`_`[polymorphism`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Polymorphism_(computer_science)]`_`f principle, which briefly is defined as "one interface, many implementations". Other OOP principles, `F33f`_`[inheritance`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Inheritance_(object-oriented_programming)]`_`f and `F33f`_`[encapsulation`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Encapsulation_(object-oriented_programming)]`_`f, are related both to methods and attributes. Method inheritance is included in type inheritance. Encapsulation in OOP is a visibility degree declared, for example, through the `B100`F9d9public`f`b, `B100`F9d9private`f`b and `B100`F9d9protected`f`b `F33f`_`[access modifiers`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Access_modifiers]`_`f.

>>History

Object–relational database management systems grew out of research that occurred in the early 1990s. That research extended existing relational database concepts by adding `F33f`_`[object`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object_(computer_science)]`_`f concepts. The researchers aimed to retain a declarative query-language based on `F33f`_`[predicate calculus`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Predicate_logic]`_`f as a central component of the architecture. Probably the most notable research project, Postgres (UC Berkeley), spawned two products tracing their lineage to that research: `F33f`_`[Illustra`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Illustra]`_`f and `F33f`_`[PostgreSQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=PostgreSQL]`_`f.

In the mid-1990s, early commercial products appeared. These included Illustra`:cite-ref-stonebraker-5-0[`F5bf`_`[5`#cite-note-stonebraker-5]`_`f] (Illustra Information Systems, acquired by `F33f`_`[Informix Software`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=IBM_Informix]`_`f, which was in turn acquired by International Business Machines (`F33f`_`[IBM`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=IBM]`_`f), Omniscience (Omniscience Corporation, acquired by `F33f`_`[Oracle Corporation`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Oracle_Corporation]`_`f and became the original Oracle Lite), and UniSQL (UniSQL, Inc., acquired by `F33f`_`[KCOM Group`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=KCOM_Group]`_`f). Ukrainian developer Ruslan Zasukhin, founder of Paradigma Software, Inc., developed and shipped the first version of Valentina database in the mid-1990s as a `F33f`_`[C++`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=C++]`_`f `F33f`_`[software development kit`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Software_development_kit]`_`f (SDK). By the next decade, PostgreSQL had become a commercially viable database, and is the basis for several current products that maintain its ORDBMS features.

Computer scientists came to refer to these products as "object–relational database management systems" or ORDBMSs.`:cite-ref-term-6-0[`F5bf`_`[6`#cite-note-term-6]`_`f]

Many of the ideas of early object–relational database efforts have largely become incorporated into `F33f`_`[SQL:1999`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=SQL]`_`f via `F33f`_`[structured types`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Structured_type]`_`f. In fact, any product that adheres to the object-oriented aspects of SQL:1999 could be described as an object–relational database management product. For example, `F33f`_`[IBM Db2`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=IBM_Db2]`_`f, `F33f`_`[Oracle Database`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Oracle_Database]`_`f, and `F33f`_`[Microsoft SQL Server`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Microsoft_SQL_Server]`_`f, make claims to support this technology and do so with varying degrees of success.

>>Comparison to RDBMS

An RDBMS might commonly involve `F33f`_`[SQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=SQL]`_`f statements such as these:

`B100`F9d9 CREATE TABLE Customers (`f`b

`B100`F9d9 Id CHAR(12) NOT NULL PRIMARY KEY,`f`b

`B100`F9d9 Surname VARCHAR(32) NOT NULL,`f`b

`B100`F9d9 FirstName VARCHAR(32) NOT NULL,`f`b

`B100`F9d9 DOB DATE NOT NULL # DOB: Date of Birth`f`b

`B100`F9d9 );`f`b

`B100`F9d9 SELECT InitCap(C.Surname) || ', ' || InitCap(C.FirstName)`f`b

`B100`F9d9 FROM Customers C`f`b

`B100`F9d9 WHERE Month(C.DOB) = Month(getdate())`f`b

`B100`F9d9 AND Day(C.DOB) = Day(getdate())`f`b

Most current SQL databases allow the crafting of custom `F33f`_`[functions`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Function_(computer_science)]`_`f, which would allow the query to appear as:

`B100`F9d9 SELECT Formal(C.Id)`f`b

`B100`F9d9 FROM Customers C`f`b

`B100`F9d9 WHERE Birthday(C.DOB) = Today()`f`b

In an object–relational database, one might see something like this, with user-defined data-types and expressions such as `B100`F9d9BirthDay()`f`b:

`B100`F9d9 CREATE TABLE Customers (`f`b

`B100`F9d9 Id Cust_Id NOT NULL PRIMARY KEY,`f`b

`B100`F9d9 Name PersonName NOT NULL,`f`b

`B100`F9d9 DOB DATE NOT NULL`f`b

`B100`F9d9 );`f`b

`B100`F9d9 SELECT Formal( C.Id )`f`b

`B100`F9d9 FROM Customers C`f`b

`B100`F9d9 WHERE BirthDay ( C.DOB ) = TODAY;`f`b

The object–relational model can offer another advantage in that the database can make use of the relationships between data to easily collect related records. In an `F33f`_`[address book`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Address_book]`_`f application, an additional table would be added to the ones above to hold zero or more addresses for each customer. Using a traditional RDBMS, collecting information for both the user and their address requires a "join":

`B100`F9d9 SELECT InitCap(C.Surname) || ', ' || InitCap(C.FirstName), A.city`f`b

`B100`F9d9 FROM Customers C JOIN Addresses A ON A.Cust_Id=C.Id -- the join`f`b

`B100`F9d9 WHERE A.city="New York"`f`b

The same query in an object–relational database appears more simply:

`B100`F9d9 SELECT Formal( C.Name )`f`b

`B100`F9d9 FROM Customers C`f`b

`B100`F9d9 WHERE C.address.city="New York" -- the linkage is 'understood' by the ORDB`f`b

>>See also

• `F33f`_`[Document-oriented database`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Document-oriented_database]`_`f

• `F33f`_`[SQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=SQL]`_`f

• `F33f`_`[Comparison of object–relational database management systems`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Comparison_of_object–relational_database_management_systems]`_`f

• `F33f`_`[Structured Type`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Structured_type]`_`f

• `F33f`_`[Object database`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object_database]`_`f

• `F33f`_`[Object–relational mapping`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object–relational_mapping]`_`f

• `F33f`_`[Relational model`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Relational_model]`_`f

• `F33f`_`[Language Integrated Query`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Language_Integrated_Query]`_`f

• `F33f`_`[Entity Framework`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Entity_Framework]`_`f

>>References

`:cite-note-usdt01-1`!1.`! `*Data Integration Glossary`* (PDF), US: Department of Transportation, August 2001, archived from the original (PDF) on 2016-09-24, retrieved 2014-03-08

`:cite-note-fstajano-2`!2.`! `F0af`_`[↑`#cite-ref-fstajano-2-0]`_`f `:citereffrank-stajano1995`aFrank Stajano (1995), `*A Gentle Introduction to Relational and Object Oriented Databases`* (PDF)

`:cite-note-namansg-3`!3.`! `F0af`_`[↑`#cite-ref-namansg-3-0]`_`f `:citerefnaman-sogani2015`aNaman Sogani (2015), `*Technical Paper Review`* (PDF), archived from the original (PDF) on 2016-03-04, retrieved 2015-10-05

`:cite-note-4`!4.`! `F0af`_`[↑`#cite-ref-4]`_`f `:citerefdatedarwen`aDate, Christopher ‘Chris’ J.; `F33f`_`[Darwen, Hugh`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Hugh_Darwen]`_`f, `*The Third Manifesto`*

`:cite-note-stonebraker-5`!5.`! `F0af`_`[↑`#cite-ref-stonebraker-5-0]`_`f Stonebraker,. Michael with Moore, Dorothy. `*Object–Relational DBMSs: The Next Great Wave`*. Morgan Kaufmann Publishers, 1996. `F33f`_`[ISBN`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=ISBN_(identifier)]`_`f 1-55860-397-2.

`:cite-note-term-6`!6.`! `F0af`_`[↑`#cite-ref-term-6-0]`_`f There was, at the time, a dispute whether the term was coined by `F33f`_`[Michael Stonebraker`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Michael_Stonebraker]`_`f of Illustra or Won Kim of UniSQL.

>>External links

Wikimedia Commons has media related to

Object-Oriented models

• `:citerefsavushkin2003`aSavushkin, Sergey (2003), `*A Point of View on ORDBMS`*, archived from the original on 2012-03-01, retrieved 2012-07-21.

• `*JPA Performance Benchmark`* – comparison of Java JPA ORM Products (Hibernate, EclipseLink, OpenJPA, DataNucleus).

• `*PolePosition Benchmark`* – shows the performance trade-offs for solutions in the `F33f`_`[object–relational impedance mismatch`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Object–relational_impedance_mismatch]`_`f context.

`c`F0af`_`[↑ Back to top`#top]`_`f`a